Classification of DBMS | Types of Database Management System

-

 

Classification of Database Management Systems (Types of DBMS)

Introduction

A Database Management System (DBMS) is software used to create, store, organize, retrieve, and manage data efficiently.

DBMS can be classified into different types based on its working mechanism, number of users, database location, and purpose.

Understanding these classifications helps us identify how databases are used in personal computers, small organizations, large enterprises, and business applications.

1. Classification Based on Working Mechanism

Based on the working mechanism, DBMS is classified into two types:

A. Passive Database Management System

A Passive Database Management System is a program-driven system in which users or application programs explicitly send requests to the DBMS.

Features:

  • It responds to requests initiated by users or application programs.
  • It retrieves information currently available in the database.
  • Applications send requests and wait for responses.
  • It performs operations such as data retrieval, insertion, deletion, updating, and schema modification.

Example: When a student requests examination results through a college website, the DBMS retrieves and displays the available results.

B. Active Database Management System

An Active Database Management System is a data-driven or event-driven system that monitors specified information or events and can respond automatically when relevant conditions occur.

Features:

  • It monitors relevant data and events.
  • It can respond automatically when specified conditions are met.
  • It can provide information to relevant users or applications.
  • It can initiate actions rather than only waiting for application requests.

Example: A store's database automatically sends a notification to the concerned staff when product stock reaches a specified minimum level.

Difference Between Passive and Active DBMS

Passive DBMSActive DBMS
Program-drivenData-driven or event-driven
Responds to explicit requestsResponds to specified events
Retrieves currently available informationCan monitor for future information or events
Applications initiate requestsDBMS can also initiate actions

2. Classification Based on Number of Users

Based on the number of users accessing the database, DBMS is classified into two types.

A. Single-User Database

A Single-User Database supports only one user at a time.

Features:

  • Only one user can access the database at a particular time.
  • Other users must wait until the current user finishes.
  • A database running on a personal computer is commonly called a Desktop Database.

Example: A personal database maintained by an individual on a computer.

B. Multi-User Database

A Multi-User Database supports multiple users accessing the database simultaneously.

Features:

  • Multiple users can access the database at the same time.
  • It is commonly used in organizations and institutions.
  • It supports shared access to information.


3. Classification Based on Database Location

Based on the location of data, databases are classified into two types.

A. Centralized Database

A Centralized Database stores and manages data at a single location or site.


B. Distributed Database

A Distributed Database stores data across several different locations or sites.


4. Classification Based on Purpose

Based on their purpose, databases are classified into two types.

A. Operational Database

An Operational Database is designed primarily to support the day-to-day operations of an organization.

B. Data Warehouse

A Data Warehouse focuses on storing data used to generate information for tactical and strategic decision-making.

For PDF: click here

For Video: click here

Conclusion

Database Management Systems can be classified based on working mechanism, number of users, location, and purpose.

The major types include Passive DBMS, Active DBMS, Single-User Database, Multi-User Database, Centralized Database, Distributed Database, Operational Database, and Data Warehouse.

Understanding these types helps students learn how databases are organized and used in different real-world applications.

Comments

Post a Comment

Popular posts from this blog

EXPLAIN THE PLATFORMS FOR BUILDING AI APPLICATIONS/ APPLICATIONS OF AI

-
Image
  EXPLAIN THE PLATFORMS FOR BUILDING AI APPLICATIONS     AI applications can be built using different platforms.     Two main types: •       Online (Cloud-based) •       Desktop (No-code/Low-code) FOR PDF : click here FOR YOUTUBE VIDEO AND EXPLAINATION : click here  © 2026 Degree IT Academy. Unauthorized copying or redistribution is prohibited. © 2026 Degree IT Academy.  This material is protected under copyright law. No part of this document may be copied, stored,  or transmitted in any form without written permission from the author.
Read more

Explain the hardware used in building AI applications.

-
  Explain the hardware used in building AI applications . Þ    Artificial intelligence (AI) computer hardware and design principles enable AI developers to run machine learning algorithms and huge datasets in data centers. Þ    Hardware implementation of AI involves the design and execution of different components that are vital to AI systems, including processors, memory, and Storage . Þ    AI algorithms require a tremendous amount of computing power for their proper functioning, and hardware plays a crucial role in providing this support.     FOR PDF: click here    FOR VIDEO AND YOUTUBE EXPLANATION: click here
Read more

Explain different processors used in AI applications.

-
  Artificial Intelligence, or AI, is a technology that allows computers and machines to think and work like humans. AI can learn from data, make decisions, recognize speech, and solve problems. Examples of AI include Google Assistant, Siri, self-driving cars, face recognition, and YouTube recommendations. AI is widely used in healthcare, education, banking, and agriculture. It helps save time, improve accuracy, and automate tasks. In simple words, Artificial Intelligence means making machines intelligent. 1. Explain different processors used in AI applications. Processors are the brain of AI systems. They perform calculations and run AI models. FOR PDF click here © 2026 Degree IT Academy. Unauthorized copying or redistribution is prohibited. © 2026 Degree IT Academy.  This material is protected under copyright law. No part of this document may be copied, stored,  or transmitted in any form without written permission from the author.
Read more